GrapeCity.CalcEngine.Functions Namespace > CalcAverageIfFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 2 - 3 items: range, criteria, [average_range].
Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.
[Average_range] is the actual set of cells to average. If omitted, range is used.
'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As System.Object _ ) As System.Object
'Usage Dim instance As CalcAverageIfFunction Dim args() As System.Object Dim value As System.Object value = instance.Evaluate(args)
public override System.object Evaluate( System.object[] args )
The args contains 2 - 3 items: range, criteria, [average_range].
Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.
[Average_range] is the actual set of cells to average. If omitted, range is used.
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)